//Figure 6: Product Auditability
//Author  : Sriram Rajagopalan


//Baseline
Table Baselines {
  Baseline_Id integer [pk]
  Project_Id integer
  Release_Id integer
  ChangeSet_Id integer
  Note:'Stores Baseline information for releases at the product'
}

//History
Table HistoryChangeSets {
  ChangeSet_Id integer [pk]
  Artifact_Type_Id integer
  Artifact_Id integer
  Project_Id integer
  Note:'Stores History changes at the product artifact level'
}

Table HistoryDetails {
  ChangeSet_Id integer
  Artifact_Type_Id integer
  Artifact_Id integer
  Custom_Property_Id integer
  Note: 'Stores History Details at the Artifact level'
}

//Custom Lists
Table CustomLists {
  Custom_Property_List_Id integer [pk]
  Project_Id integer
  Project_Template_Id integer
  Note: 'Template: Stores Custom Lists for Product'
}

Table CustomListValues {
  Custom_Property_Value_Id integer [pk]
  Custom_Property_List_Id integer
  Project_Id integer
  Note: 'Template: Stores Values for the Custom List for Product'
}

Table CustomPropertyDefinitions {
  Custom_Property_Id integer
  Custom_Property_List_Id integer
  Project_Id integer
  Project_Template_Id integer
  Note: 'Stores Product Level Custom Property Definitions'
}

Table GlobalCustomPropertyDefinitions {
  Custom_Property_Id integer [pk]
  Custom_Property_List_Id integer
  Note: 'Global: Stores Definitions for the Custom Property'  
}

Table GlobalCustomLists {
  Custom_Property_List_Id integer [pk]
  Note: 'Global: Stores Definitions for the Custom List'    
}

Table GlobalCustomListValues {
  Custom_Property_Value_Id integer [pk]
  Custom_Property_List_Id integer
  Note: 'Global: Stores Values for the Custom List'    
}

Table GlobalHistoryChangeSets {
  ChangeSet_Id integer [pk]
  Artifact_Id integer
  Artifact_Type_Id integer
  Note: 'Global: Stores History changes'    
}

Table GlobalHistoryDetails {
  Artifact_History_Id integer [pk]
  ChangeSet_Id integer 
  Note: 'Global: Stores History details'      
}

//Minimal Relationships
//Baseline & History
Ref: "Baselines"."ChangeSet_Id" - "HistoryChangeSets"."ChangeSet_Id"
Ref: "HistoryChangeSets"."ChangeSet_Id" - "HistoryDetails"."ChangeSet_Id"
Ref: "HistoryDetails"."Custom_Property_Id" - "CustomPropertyDefinitions"."Custom_Property_Id"

//Product Level Custom List and Values
Ref: "CustomListValues"."Custom_Property_List_Id" - "CustomPropertyDefinitions"."Custom_Property_List_Id"
Ref: "CustomLists"."Custom_Property_List_Id" - "CustomListValues"."Custom_Property_List_Id"

//Global History Change and Details
Ref: "GlobalHistoryChangeSets"."ChangeSet_Id" - "HistoryChangeSets"."ChangeSet_Id"
Ref: "GlobalCustomPropertyDefinitions"."Custom_Property_List_Id" - "GlobalCustomLists"."Custom_Property_List_Id"
Ref: "GlobalCustomLists"."Custom_Property_List_Id" - "GlobalCustomListValues"."Custom_Property_List_Id"
Ref: "GlobalHistoryChangeSets"."ChangeSet_Id" - "GlobalHistoryDetails"."ChangeSet_Id"